Budget and Expenditure by Quarter

You use this report to extract information about expenditure per quarter and to match the expenditure to the current budget.

The report has 3 different layouts:

Overview of data for all 4 quarters
Monthly view for a selected quarter
Budget details by quarter

The layout displayed depends on selection screen parameters.

Prerequisites

You have mapped the chapters to the commitment item groups in Customizing, under Public Sector Management Funds Management Government Master Data Account Assignment Elements Commitment Item Country-Specific Settings Qatar Map Chapters to Commitment Item Groups .
You have defined the relationship between the FM area and the company code that is to get the get the header and signature texts for report in Customizing, under Public Sector Management Funds Management Government Information System Define the Company Code to get Role IDs for a FM Area .
You have activated the online payment update. This ensures that FM documents are correctly updated when a payment document is created. To make this setting, select Online Pymnt Update in Customizing for Public Sector Management under Funds Management Government Actual and Commitment Update/Integration Integration Define Settings for Payment Transfer .
For information about the integration of Funds Management with FI, see Recording Actual and Commitment Data

Features

Selection

On the selection screen, enter the following data:

FM Area
Version
Budget Category
Fiscal Year
Fiscal Quarter
Funds Center Group
Funds Center
Commitment Items Group
Commitment Item
Chapter: You can select the chapter you want to analyze (1, 2, 3 or 4) or you can select All Chapters (in which case a PDF-based form is generated for each of the chapters).
View: You can select either Budget or Budget and Expenses:
- If you select Budget, a layout displaying budget details per quarter is selected.
- If you select Budget and Expenses, either an overview of data for all 4 quarters or a monthly view for a selected quarter is displayed (depending on whether or not you have selected Single Quarter by Month).
Single Quarter by Month
Output Description: Specify whether the standard, original, or an alternative description is to be used for commitment items.
Scaling: You can use the amounts scaling option to determine the value scale for amounts. For example, you can choose to display values in hundreds, thousands, and so on.
Only Posted Documents: If this checkbox is selected, only posted documents are considered.
Options for Background Execution: Select the language version of the PDF-based form that you want to print in background processing (that is, English or Arabic). If you want to print both language versions, you can select both checkboxes. To access the spool requests, use transaction SP01. A separate spool request is created for each printout (that is, English and/or Arabic, according to what was selected).
Layout: Select a predefined ALV layout.

Output

This report displays budget and expenditure data by quarter for each commitment item and funds center.

Note the following with respect to the data that is output:

Agreements Balance: The Agreements Balance column shows the sum of the amounts from the funds commitment and purchase order documents.
Budget Category/Ledger: The budget category is to be considered differently depending on the data you are dealing with. The goal is to display all consumption data even if the end user does not select the corresponding budget category (on the selection screen).
Budget Data: Budget data for the budget category entered on the selection screen is displayed.
Earmarked Funds Documents: Shows consumption for reservation orders, agreement orders, and purchase orders using the commitment budget ledger (9B). This is because, with update profile 0350, reservation orders, agreement orders, and purchase orders consume only commitment budget.
FI Documents: Shows consumption for obligation orders and payments using the payment budget ledger. This is because, with update profile 0350, payments consume only payment budget.
How Is the Budget Balance Calculated?: Depending on the budget category selected, you have different analysis options:
- If you select payment budget, you can match the budget against current expenditure; the budget balance shows the difference between the current payment budget and the total expenditure (obligation orders plus payments).
- If you select commitment budget, you can match this budget against funds that have been earmarked (represented by reservation orders and agreement orders) and the total expenditure. In this case, the budget balance shows the difference between the current commitment budget and the total of the open amounts for reservation orders, agreement orders, obligations, and payments.

The data is displayed in the SAP List Viewer (ALV). You can use the standard functions in the ALV to sort, sum, filter data, or perform any other functions as required.

For more information, see Working with Lists. In addition, if you select Print Report, you can print the report in a PDF-based format. This printout displays the same data as the SAP List Viewer. Both Arabic and English versions are available.

Activities

To access the report, on the SAP Easy Access screen, choose Start of the navigation path Accounting Next navigation step Public Sector Management Funds Management Information System Country-Specific Functions Country-Specific Reports for Qatar Budget and Expenditure by Quarter End of the navigation path .